CREATE TABLE [dbo].[Book_Author]
(
[BookId] [int] NOT NULL,
[AuthorId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Book_Author] ADD CONSTRAINT [PK_Book_Author] PRIMARY KEY CLUSTERED  ([BookId], [AuthorId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Book_Author] ADD CONSTRAINT [FK_Book_Author_Author] FOREIGN KEY ([AuthorId]) REFERENCES [dbo].[Author] ([Id])
GO
ALTER TABLE [dbo].[Book_Author] ADD CONSTRAINT [FK_Book_Author_Book] FOREIGN KEY ([BookId]) REFERENCES [dbo].[Book] ([Id])
GO
